Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# DB_CREATE_FILE_DEST

Property | Description
--- | ---
Parameter type | String
Syntax | `DB_CREATE_FILE_DEST =` `directory` `|` `disk group`
Default value | There is no default value.
Modifiable | `ALTER SESSION`, `ALTER SYSTEM`
Basic | Yes

`DB_CREATE_FILE_DEST` specifies the default location for Oracle-managed datafiles. This location is also used as the default location for Oracle-managed control files and online redo logs if none of the `DB_CREATE_ONLINE_LOG_DEST_``n` initialization parameters are specified.

If a file system directory is specified as the default location, then the directory must already exist; Oracle does not create it. The directory must have appropriate permissions that allow Oracle to create files in it. Oracle generates unique names for the files, and a file thus created is an Oracle-managed file.

See Also: Oracle Database Administrator's Guide for more information on setting this parameter and on Oracle-managed files